CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

IsThere_Remote

Checks if a file can be reached online or no Same as

VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

UnProtect.zip

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

dbmysqlvbapi.zip

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

OpenOffice Calc

OpenOffice programming with Visual Basic Some document I had for my reference.

Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...